/*
 Navicat SQL Server Data Transfer

 Source Server         : 47.110.88.212
 Source Server Type    : SQL Server
 Source Server Version : 14003048
 Source Host           : 47.110.88.212:1433
 Source Catalog        : test111
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 14003048
 File Encoding         : 65001

 Date: 07/12/2020 16:59:21
*/


-- ----------------------------
-- Table structure for vote_awards
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards]
  GO

CREATE TABLE [dbo].[vote_awards] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [start_time] datetime  NULL,
  [end_time] datetime  NULL,
  [flower] int DEFAULT 99 NULL,
  [votes] int DEFAULT 1 NULL,
  [votes_same] int DEFAULT 1 NULL,
  [date_type] int  NULL,
  [create_type] int DEFAULT 1 NULL,
  [about] ntext COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [regular] ntext COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [create_time] datetime  NULL,
  [creator] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [update_time] datetime  NULL,
  [updater] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [is_del] tinyint DEFAULT 0 NULL,
  [audit_time] datetime  NULL,
  [release] datetime  NULL,
  [awardType] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards] SET (LOCK_ESCALATION = AUTO)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'开始时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'start_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'结束时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'end_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'送花数量：默认人均99朵',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'flower'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票规则：默认人均1张',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'votes'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票规则：同一个人允许投几票',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'votes_same'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'时间类型：1 年度 2 季度',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'date_type'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'创建类型：1 BMP 2 OA',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'create_type'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'活动介绍',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'about'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项规则介绍',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'regular'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'是否删除：0 未删除 1 已删除',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'is_del'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'BPM审核通过时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'audit_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项发布时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'release'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'里程碑奖，价值观奖， 年度专项奖-HR，年度专项奖-HSE',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards',
  'COLUMN', N'awardType'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项配置',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards'
  GO


  -- ----------------------------
  -- Table structure for vote_awards_ballot
  -- ----------------------------
  IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards_ballot]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards_ballot]
  GO

CREATE TABLE [dbo].[vote_awards_ballot] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [awards_id] int  NOT NULL,
  [awards_participator_id] int  NOT NULL,
  [user_id] int  NOT NULL,
  [create_time] datetime  NOT NULL,
  [update_time] datetime  NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards_ballot] SET (LOCK_ESCALATION = AUTO)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项配置ID',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_ballot',
  'COLUMN', N'awards_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票名单id（投给谁）',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_ballot',
  'COLUMN', N'awards_participator_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票人userId',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_ballot',
  'COLUMN', N'user_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票记录',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_ballot'
  GO


  -- ----------------------------
  -- Table structure for vote_awards_flower
  -- ----------------------------
  IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards_flower]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards_flower]
  GO

CREATE TABLE [dbo].[vote_awards_flower] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [awards_id] int  NOT NULL,
  [awards_participator_id] int  NOT NULL,
  [user_id] int  NOT NULL,
  [create_time] datetime  NULL,
  [update_time] datetime  NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards_flower] SET (LOCK_ESCALATION = TABLE)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项配置ID',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_flower',
  'COLUMN', N'awards_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'投票名单id（送给谁）',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_flower',
  'COLUMN', N'awards_participator_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'送花人userId',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_flower',
  'COLUMN', N'user_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'送花记录',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_flower'
  GO


  -- ----------------------------
  -- Table structure for vote_awards_message
  -- ----------------------------
  IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards_message]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards_message]
  GO

CREATE TABLE [dbo].[vote_awards_message] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [awards_participator_id] int  NOT NULL,
  [name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [photo] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [dept] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [message] ntext COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [create_time] datetime  NOT NULL,
  [update_time] datetime  NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards_message] SET (LOCK_ESCALATION = TABLE)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'提名名单id',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'awards_participator_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'留言人名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'留言人头像',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'photo'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'留言人部门名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'dept'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'消息',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'message'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'创建时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message',
  'COLUMN', N'create_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'留言',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_message'
  GO


  -- ----------------------------
  -- Table structure for vote_awards_participator
  -- ----------------------------
  IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards_participator]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards_participator]
  GO

CREATE TABLE [dbo].[vote_awards_participator] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [awards_id] int  NOT NULL,
  [awards_subname_id] int DEFAULT 0 NOT NULL,
  [member_names] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [about] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [declaration] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [poject_num] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [applicant_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [applicant_dept_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [applicant_position] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_dept_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_position] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_photo] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_type] int DEFAULT 0 NULL,
  [nominator_status] int DEFAULT 0 NULL,
  [win_status] tinyint DEFAULT 0 NULL,
  [complete] ntext COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [influence] ntext COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [is_economic] tinyint DEFAULT 0 NULL,
  [save_money] decimal(20) DEFAULT 0 NULL,
  [flower_num] int DEFAULT 0 NULL,
  [message_num] int DEFAULT 0 NULL,
  [member_json_array] nvarchar(1000) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [votes_num] int DEFAULT 0 NULL,
  [create_time] datetime  NULL,
  [update_time] datetime  NULL,
  [applicant_second_dept_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nominator_second_dept_name] nvarchar(255) COLLATE SQL_Latin1_General_CP437_BIN  NULL,
  [nominator_project_name] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CS_AS  NULL,
  [project_goal] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [poject_start_time] datetime DEFAULT '' NULL,
  [poject_end_time] datetime  NULL,
  [is_del] tinyint DEFAULT 0 NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards_participator] SET (LOCK_ESCALATION = TABLE)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项配置id',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'awards_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'参与类型 vote_awards_subname.id ：1 客户满意 2 激流勇进 3 天鹅奖 4 技术新力量 5 变革先锋 6 百尺竿头 7 匠心奖 8 领导力 9 利他奖 10 园丁奖 11 工厂之星 12 模范班组',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'awards_subname_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'参与成员名称用/分隔',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'member_names'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'提名简介',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'about'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'提名宣言',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'declaration'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'项目编号',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'poject_num'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'申请人名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'applicant_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'申请人部门名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'applicant_dept_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'申请人职位',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'applicant_position'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名部门名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_dept_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名职位',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_position'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名照片（参与人头像）',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_photo'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名类型：1 个人 2 团队',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_type'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'被提名状态：0 待提名 1 提名中 -1 提名驳回',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_status'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'获奖状态：0 未获将 1 获奖',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'win_status'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'完成了什么',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'complete'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'成就/影响',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'influence'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'是否有经济效益：0 没有 1 有',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'is_economic'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'节约金额',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'save_money'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'送花数量',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'flower_num'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'留言数量',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'message_num'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'团队类型：成员信息 JSON对象',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'member_json_array'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'得票数量',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'votes_num'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'申请人二级部门',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'applicant_second_dept_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'提名人二级部门',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_second_dept_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'提名項目名称-团队使用',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'nominator_project_name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'方案目标',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'project_goal'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'项目开始时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'poject_start_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'项目结束时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'poject_end_time'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'0:未被删除 1：已经被删除',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator',
  'COLUMN', N'is_del'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'参与名单',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_participator'
  GO


  -- ----------------------------
  -- Table structure for vote_awards_subname
  -- ----------------------------
  IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[vote_awards_subname]') AND type IN ('U'))
DROP TABLE [dbo].[vote_awards_subname]
  GO

CREATE TABLE [dbo].[vote_awards_subname] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [name] nvarchar(255) COLLATE SQL_Latin1_General_CP437_CS_AS  NULL,
  [awards_id] int DEFAULT 0 NOT NULL,
  [status] int DEFAULT 0 NULL,
  [msg_status] int DEFAULT 0 NULL,
  [create_time] datetime  NULL,
  [creator] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [is_del] tinyint DEFAULT 0 NOT NULL,
  [release_time] datetime  NULL
  )
  GO

ALTER TABLE [dbo].[vote_awards_subname] SET (LOCK_ESCALATION = TABLE)
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'子奖项名称',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'name'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'奖项id',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'awards_id'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'子奖项状态：0 待发布 1 进行中 -1 已结束',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'status'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'消息推送状态（如果状态变更，需要恢复消息推送状态为0，兼容发布消息推送与获奖推送）：0 未推送 1 已推送',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'msg_status'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'是否删除：默认 0 未删除 1 已删除',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'is_del'
  GO

  EXEC sp_addextendedproperty
  'MS_Description', N'子奖项发布时间',
  'SCHEMA', N'dbo',
  'TABLE', N'vote_awards_subname',
  'COLUMN', N'release_time'
  GO


  -- ----------------------------
  -- Auto increment value for vote_awards
  -- ----------------------------
  DBCC CHECKIDENT ('[dbo].[vote_awards]', RESEED, 1)
  GO


  -- ----------------------------
  -- Auto increment value for vote_awards_ballot
  -- ----------------------------
  DBCC CHECKIDENT ('[dbo].[vote_awards_ballot]', RESEED, 1)
  GO


  -- ----------------------------
  -- Auto increment value for vote_awards_flower
  -- ----------------------------
  DBCC CHECKIDENT ('[dbo].[vote_awards_flower]', RESEED, 1)
  GO


  -- ----------------------------
  -- Auto increment value for vote_awards_message
  -- ----------------------------
  DBCC CHECKIDENT ('[dbo].[vote_awards_message]', RESEED, 1)
  GO


  -- ----------------------------
  -- Auto increment value for vote_awards_participator
  -- ----------------------------
  DBCC CHECKIDENT ('[dbo].[vote_awards_participator]', RESEED, 1)
  GO


-- ----------------------------
-- Indexes structure for table vote_awards_participator
-- ----------------------------
CREATE NONCLUSTERED INDEX [idx_awards]
ON [dbo].[vote_awards_participator] (
  [awards_id] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_awards_subname]
ON [dbo].[vote_awards_participator] (
  [awards_subname_id] ASC
)
GO


-- ----------------------------
-- Auto increment value for vote_awards_subname
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[vote_awards_subname]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table vote_awards_subname
-- ----------------------------
ALTER TABLE [dbo].[vote_awards_subname] ADD CONSTRAINT [PK__vote_awa__3213E83FFCDD275E] PRIMARY KEY CLUSTERED ([id])
  WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
  ON [PRIMARY]
  GO

